Josh and Tom,
I have checked for typos, rewritten a smaller script and checked the table setup (\d gb, see below) and
$result = $conn->exec(
"SELECT currval('gb_gb_id_seq');"
);
continues to return the error:
ERROR: gb_gb_id_seq.currval is not yet defined in this session
I know this script worked in the past, but I have not used it recently. We are running PostgreSQL 7.1.3. It would be great if this would work as I have several scripts which operate in a similar manner for different TABLES, but if it won't work I'll work around it.
Suggestions for the best way to get the value for the gb_id after an INSERT?
chlamy_est=> \d gb
Table "gb"
Attribute | Type | Modifier
-----------+-----------------------+--------------------------------------------------
gb_id | integer | not null default nextval('"gb_gb_id_seq"'::text)
clone_id | integer |
accn | character varying(12) | not null
gi | integer | not null
Index: gb_pkey
Hmm, that sure looks like it should work. I can only counsel looking
for silly errors (typos, not running the same copy of the script that you
edited, etc). Also double-check that gb.gb_id has the column default
nextval('gb_gb_id_seq') (try psql's "\d gb" command).
--
Regards,
Chuck